<?php
	/*Pagina que exibe os objetos do banco de experiencias daquele curso*/

	session_start();
	include("/var/www/html/vivencias/conexaoBD.php");

	$idCategoria = $_GET['idCategoria'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Experi&ecirc;ncias do Processo de Adoecimento</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="vivencias.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">

function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}


function confirmBox(obj) {

	if (confirm("Ao excluir uma subcategoria, seu conteudo tambem sera excluido. Tem certeza que deseja prosseguir?")) {

		formulario = document.formSubCategorias;
		formulario.method = "POST";
		formulario.action = "acoesSubCategoriasCursoCorrente.php";
		formulario.submit();		

	}
}
//-->
</script>
</head>

<body onLoad="MM_preloadImages('imagens/stt_cadastro2.jpg','imagens/stt_relator2.jpg','imagens/stt_estat2.jpg','imagens/stt_definI2.jpg')">
<div align="center">
  <table width="1000" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="10%" align="left" valign="top"><img src="imagens/logo.jpg" width="66" height="53"></td>
                  <td width="90%"><img src="imagens/tit1.jpg" width="612" height="28"></td>
                </tr>
              </table></td>
          </tr>
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr align="left" valign="middle">
                  <td colspan="3" class="nomecurso"><?php echo $_SESSION['nomeCurso'];?></td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td><a href="index.php"><img src="imagens/sair.gif" width="33" height="19" border="0"></a></td>
                </tr>
                <tr align="left" valign="middle">
                  <td width="25%">&nbsp;</td>
                  <td width="22%">&nbsp;</td>
                  <td width="52%">&nbsp;</td>
                  <td width="0%">&nbsp;</td>
                  <td width="0%">&nbsp;</td>
                  <td width="1%">&nbsp;</td>
                </tr>
              </table></td>
          </tr>
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr align="left" valign="top">
                  <td width="2%" background="imagens/bar_fnd_8.jpg" bgcolor="EBF4F9"><a href="relatorios.htm"><img src="imagens/mn_8.jpg" width="23" height="161" border="0"></a></td>
                  <td width="60%" align="center" valign="top" bgcolor="f4f1fc">
                    <table width="816" border="0" cellpadding="0" cellspacing="0">
                      <tr align="left" valign="top">
                        <td width="10"><img src="imagens/pix_cor7b.gif" width="10" height="5"></td>
                        <td width="73"><a href="listagemAlunos.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('cadastro','','imagens/stt_cadastro2.jpg',1)"><img src="imagens/stt_cadastro1.jpg" name="cadastro" width="73" height="21" border="0"></a></td>
                        <td width="10"><img src="imagens/pix_cor7b.gif" width="10" height="5"></td>
                        <td width="52"><img src="imagens/stt_banco2.jpg" width="52" height="21"></td>
                        <td width="10"><img src="imagens/pix_cor7b.gif" width="10" height="5"></td>
                        <td width="81"><a href="relatorios.htm" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('relatorios','','imagens/stt_relator2.jpg',1)"><img src="imagens/stt_relator1.jpg" name="relatorios" width="81" height="21" border="0"></a></td>
                        <td width="10"><img src="imagens/pix_cor7b.gif" width="10" height="5"></td>
                        <td width="86"><a href="correcao.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('correcao','','imagens/stt_correcao2.jpg',1)"><img src="imagens/stt_correcao1.jpg" name="correcao" width="81" height="21" border="0"></a></td>
                        <td width="1"><img src="imagens/pix_cor7b.gif" width="10" height="5"></td>
                        <td width="116"><a href="d.comunica.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('definicoesiniciais','','imagens/stt_definI2.jpg',1)"><img src="imagens/stt_definI1.jpg" name="definicoesiniciais" width="140" height="21" border="0"></a></td>
                        <td width="117"><img src="imagens/pix_cor7b.gif" width="84" height="5"></td>
                      </tr>
                      <tr align="left" valign="top">
                        <td colspan="11"><table width="100%" border="0" cellpadding="0" cellspacing="0">
                            <tr>
                              <td width="1%"><img src="imagens/pix_cor7b.gif" width="10" height="5"></td>
                              <td width="41%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="3%">&nbsp;</td>
                              <td width="19%">&nbsp;</td>
                            </tr>
                          </table></td>
                      </tr>
                    </table>
                    <table width="95%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                      <tr align="right" class="texttab">
                        <td align="left" valign="bottom" bgcolor="f4f1fc"><a href="bancoCategoriasCursoCorrente.php" class="miudo">Voltar</a></td>
                        <td valign="middle" bgcolor="f4f1fc" class="titprincipal">&nbsp;</td>
                        <td valign="middle" bgcolor="f4f1fc" class="titprincipal"><a href="javascript:void(0)"  onClick="javascript:window.open('duvidaBe1.htm', 'Janela', 'toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,width=600,height=540');"><img src="imagens/duvida8.gif" width="24" height="24" border="0"></a></td>
                      </tr>
                      <tr align="center" valign="middle" class="texttab">
                        <td colspan="3" bgcolor="ddd9e9" class="texto2"> <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                            <tr class="texttab">
                              <td width="91%" align="left" valign="middle" bgcolor="9786c6" class="ativo">Banco
                                de Experi&ecirc;ncias - <?php echo $_SESSION['nomeCurso'];?></td>
                              <td width="9%" align="right" valign="middle" bgcolor="9786c6" class="titprincipal"><a href="bancoCategoriasCursoCorrente.php"><img src="imagens/x.jpg" width="21" height="21" border="0"></a></td>
                            </tr>
                          </table>
                          <div align="center"></div></td>
                      </tr>
                      <tr align="center" valign="middle" class="texttab">
                        <td colspan="3" bgcolor="ddd9e9" class="texto2"> <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                            <tr align="center" bgcolor="a99ec6" class="texttab">
                              <td colspan="3" valign="middle" class="titvermelho">
                                <div align="center"><strong><a href="javascript:void(0)"  class="texto2" onClick="javascript:window.open('form.depoimento.php?idCategoria=<?php echo $idCategoria;?>', 'Janela', 'toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,width=750,height=600');"><span class ="titvermelho">Clique
                                  aqui para inserir um novo depoimento</span></a></strong></div></td>
                            </tr>

			    <form name="formInsereSubcategoria" action="insereSubCategoriaB.php" method="post">
                            <tr bgcolor="a99ec6" class="texttab">
                              <td width="40%" align="left" valign="middle" bgcolor="a99ec6" class="titvermelho">
                                <div align="left">Criar nova subcategoria</div></td>
                              <td width="51%" align="left" valign="middle" bgcolor="a99ec6" class="titvermelho">
                                <input name="nomeSubCategoria" type="text" size="40"></td>
				<input type="hidden" name="idCategoria" value="<?php echo $idCategoria;?>">
                              <td width="9%" class="titvermelho"><input type="submit" name="btSubCategoria" value="Ok"></td>
                            </tr>
			    </form>
			    <form name="formSubCategorias">
		            <?php
					$queryCategoria     = "SELECT nome FROM categoriasBancoExperiencias WHERE idCategoria='".$idCategoria."'";
					$resultadoCategoria = mysql_query($queryCategoria,$conexao);
					$objetoCategoria    = mysql_fetch_object($resultadoCategoria);
			    ?>

                            <tr bgcolor="ddd9e9" class="texttab">
                              <td colspan="3" class="texto2"><table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                                  <tr bgcolor="9786c6">
                                    <td colspan="4" class="ativo">Categoria <?php echo $objetoCategoria->nome;?></td>
                                  </tr>
				  <?php
					$querySubC      = "SELECT * FROM subCategBancoExp WHERE idCategoria='".$idCategoria."' ORDER BY nome";
					$resultadoSubC  = mysql_query($querySubC,$conexao);
					while($objetoSubC = mysql_fetch_object($resultadoSubC)){
						$subCategorias = 1; //indica se existe alguma subcategoria

				  ?>
                                  <tr bgcolor="c6bedf">
                                    <td colspan="4">
					<input type="checkbox" name="cbExcluir[]" value="<?php echo $objetoSubC->idSubCategoria;?>"/>&nbsp;&nbsp;
					<span class="ativomenor">Subcategoria <?php echo $objetoSubC->nome;?></span>
				    </td>
                                  </tr>
				  <?php
					$queryObj     = "SELECT cursosObjetos.*,objetosBancoExperiencias.* FROM cursosObjetos,objetosBancoExperiencias WHERE cursosObjetos.idObjeto = objetosBancoExperiencias.idObjeto AND cursosObjetos.idSubCategoria='".$objetoSubC->idSubCategoria."' ORDER BY objetosBancoExperiencias.frase";
					$resultadoObj = mysql_query($queryObj,$conexao);
					$numResultObj = mysql_num_rows($resultadoObj);
					if(!$numResultObj){
				  ?>
				  <tr bgcolor="c6bedf">
                                    <td colspan="4"><span class="miudo">N&atilde;o h&aacute; depoimentos nessa categoria.</span></td>
                                  </tr>

				  <?php
					}else{
						while($objetoObj = mysql_fetch_object($resultadoObj)){
				  ?>
                                  <tr align="center" valign="middle" bgcolor="ddd9e9">
                                    <td colspan="4"> <div align="center">
                                        <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                                          <tr bgcolor="c6bedf" class="texttab">
                                            <td><a href="<?php echo $objetoObj->caminho;?>" style="text-decoration:none"><span class="azul"><strong><?php echo $objetoObj->frase;?></strong></span></a><br>
                                              <a href="<?php echo $objetoObj->caminho;?>" class="texto2"><?php echo $objetoObj->comentario;?></a></td>
                                            <td align="center" valign="middle" bgcolor="c6bedf" class="texto2"><strong>
                                              <a href="javascript:void(0)" onClick="javascript:window.open('detalhesObjetoBancoExp.php?idObjeto=<?php echo $objetoObj->idObjeto;?>', 'Janela', 'toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,width=600,height=700');">
                                              </a><img src="imagens/bot.papel2.gif" width="26" height="26">
                                              </strong></td>
                                          </tr>
					  <?php
						$queryDono     = "SELECT usuarios.nome FROM usuarios,usuariosObjetos WHERE usuariosObjetos.dono=1 AND usuariosObjetos.idObjeto='".$objetoObj->idObjeto."' AND usuarios.idUsuario=usuariosObjetos.idUsuario";
						$resultadoDono = mysql_query($queryDono,$conexao);
						$objetoDono    = mysql_fetch_object($resultadoDono);
					  ?>
                                          <tr bgcolor="c6bedf" class="texttab">
                                            <td class="texto2"><strong>Respons&aacute;vel:
                                              </strong><?php echo $objetoDono->nome;?></td>
                                            <td align="center" valign="middle" bgcolor="c6bedf"><strong><a href="javascript:void(0)" onClick="javascript:window.open('detalhesObjetoBancoExp.php?idObjeto=<?php echo $objetoObj->idObjeto;?>', 'Janela', 'toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,width=600,height=700');" class="texto2">
                                            <input type="button" name="Submit23436" value="Detalhes">
                                              </a></strong></td>
                                          </tr>
                                        </table>
                                      </div></td>
                                  </tr>
                                  <?php }}} ?>
                                </table> </td>
                            </tr>
			    <?php if($subCategorias){?>
			    <tr bgcolor="ddd9e9" class="texttab">
                              <td colspan="3" class="texto2">
					<input type="hidden" name="idCategoria" value="<?php echo $idCategoria;?>" />
					<!--<input type="submit" name="btEditar" value="Editar" onClick="confirmBox(this)";/>-->
			      		<input type="submit" name="btExcluir" value="Excluir" onClick="confirmBox(this)";/>
			      </td>
			    </tr>	
			    <?php } ?>
			   </form>
                          </table></td>
                      </tr>
                    </table>
                    <p>&nbsp;</p></td>
                  <td width="0%" align="right" background="imagens/bar_fnd_7.jpg"><a href="info.php"><img src="imagens/mn_7.jpg" width="23" height="137" border="0"></a>
                  </td>
                  <td width="8%" align="right" background="imagens/bar_fnd_6.jpg"><a href="esppess.php"><img src="imagens/mn_6.jpg" width="23" height="156" border="0"></a>
                  </td>
                  <td width="4%" align="right" background="imagens/bar_fnd_5.jpg"><a href="comunicacao.php"><img src="imagens/mn_5.jpg" width="23" height="146" border="0"></a>
                  </td>
                  <td width="5%" align="right" background="imagens/bar_fnd_4.jpg"><a href="banco.php"><img src="imagens/mn_4.jpg" width="23" height="219" border="0"></a>
                  </td>
                  <td width="4%" align="right" background="imagens/bar_fnd_3.jpg"><a href="ferramentasTrabalho.php"><img src="imagens/mn_3.jpg" width="23" height="249" border="0"></a>
                  </td>
                  <td width="2%" align="right" background="imagens/bar_fnd_2.jpg"><a href="conteudo.php"><img src="imagens/mn_2.jpg" width="23" height="113" border="0"></a></td>
                  <td width="15%" align="right" background="imagens/bar_fnd_1.jpg" bgcolor="F1FEF9">
                    <p><a href="principal.php"><img src="imagens/mn_1.jpg" width="23" height="103" border="0"></a></p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p></td>
                </tr>
              </table></td>
          </tr>
        </table></td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</div>
</body>
</html>
